Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | Item(AS_ITM) |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | SupplierItem(AS_ITM_SPR) |
SupplierItemID (FK)(PK) | The code assigned by the supplier to uniquely identify the ITEM | ID_ITM_SPR | Identity | integer | SupplierItem(AS_ITM_SPR) |
LastReceiptSaleByUnitCount | A count of retail sale unit's last received from a particular supplier for an item. | QU_SLS_UN_LS_RCV | QuantityTransactionCount | decimal(7,0) | |
LastReceiptSaleUnitBaseCost | The unit base cost (i.e. the cost excluding charges and allowances) of a retail sale unit of an item when it was last received from a particular supplier. This is used to develop average cost when a given STOCK ITEM is supplied by several suppliers. | CP_SLS_UN_LS_RCV | MoneyShortCost | decimal(16,5) | |
AssortmentFlag | A code to signify the assortment contained within the receiving pack, eg assorted colors, assorted sizes, etc. The retailer will normally predetermine the assortment with the supplier. | FL_ASRT | Flag | integer | |
AssortmentDescription | The description of the assortment the item belongs to. | DE_ASRT | DescriptionShort | varchar(255) | |